insert into seller values('admin', 'admin', '관리자', '111-111', '서울시 강남구 삼성동', '코엑스', '010-1111-2222', 'admin@naver.com', sysdate);

insert into seller values('seller1', 'seller1', '판매자1', '111-111', '서울시 강남구 삼성동', '코엑스', '010-1111-2223', 'seller1@naver.com', sysdate);
insert into seller values('seller2', 'seller2', '판매자2', '111-111', '서울시 강남구 삼성동', '코엑스', '010-1111-2224', 'seller2@naver.com', sysdate);

insert into shop values(SEQ_shop_shop_seq.nextval, 'seller1', '민선이네과일가게', 'F', '111-111', '서울시 강남구 삼성동', '코엑스', '010-1111-2224');
insert into shop values(SEQ_shop_shop_seq.nextval, 'seller2', '다이소', 'A', '111-111', '서울시 강남구 삼성동', '코엑스', '010-1111-2225');


insert into customer values('abc', 'abc', '이민선', '134-800', '경기도 안양시 안양동', '123-123', '010-1234-5678', 'abc@abc.com', sysdate);

insert into product values(SEQ_product_product_seq.nextval, 1, 'f', '사과', 1000, 'aa', 'bb', '사과입니다', '사과에요', sysdate);
insert into product values(SEQ_product_product_seq.nextval, 1, 'f', '배', 2000, 'dd', 'ee', '배입니다', '배에요', sysdate);
insert into product values(SEQ_product_product_seq.nextval, 2, 'l', '쯔메끼리', 2000, 'ff', 'gg', '쯔메끼리에요', '쯔메끼리!', sysdate);
insert into product values(SEQ_product_product_seq.nextval, 2, 'l', '와루바시', 1000, 'pp', 'zz', '와루바시에요', '와루바시!', sysdate);

insert into product_order values(
	 SEQ_product_order_order_seq.nextval
	,'abc'
	,'f'
	,'d'
	,sysdate
);

insert into order_detail values(1, 1, 3);
insert into order_detail values(1, 2, 2);
insert into order_detail values(1, 3, 1);
insert into delivery values(1, '김진표', '010-1234-5678','134-900', '서울시송파구잠실동', '123-456', '감사', '화이팅');

insert into product_order values(
	 SEQ_product_order_order_seq.nextval
	,'abc'
	,'f'
	,'s'
	,sysdate
);

insert into order_detail values(2, 2, 3);
insert into order_detail values(2, 3, 2);
insert into order_detail values(2, 4, 1);
insert into delivery values(2, '김창수', '010-1234-5678','134-900', '서울시강남구삼성동', '123-456', '메롱', '화이팅');
